*Input the community categories: 
*Read in the data:


import excel "$root/Data/Original/Raumgliederungen.xlsx", sheet("Daten") cellrange(A2:J2149) firstrow

*rename the variables:
rename StädtischeLändlicheGebiete urban3
rename BFSGdenummer GDENR

*Only keep the ID and the used category:
keep GDENR urban3

*Save the data
save "$root/Data/Original/comm_categories.dta", replace
